from openpyxl import load_workbook

excel = load_workbook(r'F:\file\a.xlsx')
sheet = excel.get_sheet_by_name("Sheet1")
print(sheet.max_column)
print(sheet.max_row)
for rown in range(1, sheet.max_row+1):
    for columnn in range(1, sheet.max_column+1):
        data = sheet.cell(row=rown, column=columnn).value
        if data:
            print(data)


# print(excel.get_sheet_names())
